package com.sxy.demo.sxy;

import lombok.Data;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Date;

/**
 *         SELECT wc.id,
 *                wc.classification_name classificationName,
 *                wc.category_group      categoryGroup,
 *                wc.enable_state        enableState,
 *                wc.sort,
 *                wc.welfare_multiple    welfareMultiple,
 *                wc.multiple_start_time multipleStartTime,
 *                wc.multiple_end_time   multipleEndTime,
 *                pi.id                  productId
 *         FROM welfare_product_classification wc
 *                  INNER JOIN welfare_product_info wp ON wc.id = wp.classification_id
 *             AND wp.state = 1
 *             AND wp.enable_state = 1
 *                  LEFT JOIN rms_goods_public_spu pi ON pi.id = wp.product_id
 *             AND ((pi.goods_type = 1 AND pi.goods_spu_state = 30) OR (pi.goods_type = 2 AND pi.goods_spu_state = 20)) AND pi.deleted =0
 *         where wp.product_id = #{productId}
 *           and wc.state = 1
 *           and wc.enable_state = 1
 */
@Data
public class WelfareProductClassificationBO implements Serializable {

    private static final long serialVersionUID = 8926247224009914194L;

    private Integer id;

    /**
     * 内购专区商品分类名称
     */
    private String classificationName;

    /**
     * 排序序号
     */
    private Integer sort;

    /**
     * 分类组（默认0）
     */
    private Integer categoryGroup;

    /**
     * 启用状态，0-关闭 1-开启
     */
    private Integer enableState;

    /**
     * 状态，0-无效 1-有效
     */
    private Integer state;

    /**
     * 贡献值倍率
     */
    private BigDecimal welfareMultiple;

    /**
     * 倍率开始时间
     */
    private Date multipleStartTime;

    /**
     * 倍率结束时间
     */
    private Date multipleEndTime;

    /**
     * 创建时间
     */
    private Date createTime;

    /**
     * 创建人
     */
    private Integer createUser;

    /**
     * 更新时间
     */
    private Date updateTime;

    /**
     * 更新人
     */
    private Integer updateUser;

    /**
     * 商品id
     */
    private Integer productId;
}
